foreign key constraints and alter table - Mailing list pgsql-general

From John DeSoi
Subject foreign key constraints and alter table
Date
Msg-id p05200f01ba773bb97555@[192.168.1.7]
Whole thread Raw
Responses Re: foreign key constraints and alter table  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
If I'm reading the docs correctly, I should be able to write:

ALTER TABLE mytable ADD ptr INT4 REFERENCES othertable ON DELETE SET NULL

but when I look in pg_constraint table (pg 7.3) I don't see any kind
of foreign key constraint.

BTW, are the PDF versions of the 7.3 Docs? I only see 7.2 on the web site.

Thanks!

John DeSoi, Ph.D.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: TIMESTAMP WITH( OUT)? TIME ZONE indexing/type choice...
Next
From: Tom Lane
Date:
Subject: Re: Index not used with IS NULL